[dbo].[EventGuest]

Property	Value
Created	10:31:20 AM Tuesday, March 02, 2010
Last Modified	1:17:32 PM Thursday, February 23, 2012

	Name	Data Type	Max Length (Bytes)	Identity
	EventGuestID	int	4	1 - 1
$Foreign Keys FK_EventGuest_EventRegistrant: [dbo].[EventRegistrant].RegistrantID\EventCode$	RegistrantID	varchar(10)	10
$Foreign Keys FK_EventGuest_EventRegistrant: [dbo].[EventRegistrant].RegistrantID\EventCode$	EventCode	varchar(15)	15
	CartEventFunctionID	int	4
$Indexes iWC: GuestBadge\LastName$	GuestBadge	varchar(32)	32
	FirstName	varchar(20)	20
	MiddleInitial	varchar(20)	20
$Indexes iWC: GuestBadge\LastName$	LastName	varchar(30)	30
	Address1	varchar(40)	40
	Address2	varchar(40)	40
	Address3	varchar(40)	40
	City	varchar(40)	40
	StateProvince	varchar(15)	15
	PostalCode	varchar(10)	10
	Country	varchar(25)	25
	Prefix	varchar(25)	25
	Suffix	varchar(10)	10
	Nickname	varchar(20)	20
	Designation	varchar(20)	20
	Title	varchar(50)	50
	Company	varchar(80)	80

	Name	Columns	Unique
	PK_EventGuest	EventGuestID
	iWC	GuestBadge, LastName
	IX_EventGuest_CartEventFunctionID	CartEventFunctionID
	IX_EventGuest_EventCode	EventCode
	IX_EventGuest_RegistrantID	RegistrantID

Name	Delete	Columns
FK_EventGuest_CartEventFunction	Cascade	CartEventFunctionID->[dbo].[CartEventFunction].[CartEventFunctionID]
FK_EventGuest_EventRegistrant		RegistrantID->[dbo].[EventRegistrant].[RegistrantID] EventCode->[dbo].[EventRegistrant].[EventCode]

SQL Script

CREATE TABLE [dbo].[EventGuest]
(
[EventGuestID] [int] NOT NULL IDENTITY(1, 1),
[RegistrantID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EventCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CartEventFunctionID] [int] NULL,
[GuestBadge] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FirstName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MiddleInitial] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StateProvince] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PostalCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Country] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Prefix] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Suffix] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Nickname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Designation] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Title] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Company] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[EventGuest] ADD CONSTRAINT [PK_EventGuest] PRIMARY KEY CLUSTERED ([EventGuestID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_EventGuest_CartEventFunctionID] ON [dbo].[EventGuest] ([CartEventFunctionID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_EventGuest_EventCode] ON [dbo].[EventGuest] ([EventCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[EventGuest] ([GuestBadge], [LastName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_EventGuest_RegistrantID] ON [dbo].[EventGuest] ([RegistrantID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventGuest] ADD CONSTRAINT [FK_EventGuest_CartEventFunction] FOREIGN KEY ([CartEventFunctionID]) REFERENCES [dbo].[CartEventFunction] ([CartEventFunctionID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[EventGuest] ADD CONSTRAINT [FK_EventGuest_EventRegistrant] FOREIGN KEY ([RegistrantID], [EventCode]) REFERENCES [dbo].[EventRegistrant] ([RegistrantID], [EventCode])
GO